﻿CREATE TABLE [dbo].[Supplier] (
    [ID_Supplier]         INT           IDENTITY (1, 1) NOT NULL,
    [Id_Company]          INT           NOT NULL,
    [Name]                VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NOT NULL,
    [CNPJ]                VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [CPF]                 VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [RG]                  VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Id_SupplierType]     INT           NOT NULL,
    [Razao_Social]        VARCHAR (100) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Inscricao_Municipal] VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Inscricao_Estadual]  VARCHAR (18)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL
);

